Excel Formulas and Functions 2021—The Intermediate Level: Step-by-Step Guide with Examples for Intermediate Level (Excel Academy Book 3) by Ramirez Adam

Author:Ramirez, Adam
Language: eng
Format: epub
Published: 2021-10-18T00:00:00+00:00

ABS

Imagine that you have taken out a $1,000 loan from a bank. In theory, that amount of money should now be represented as a negative number, given that it is a debt. When you make a monthly payment of, say, $75, you are using a positive number to work that debt back up to $0, i.e. paying off the loan. However, for many of us, those signs complicate issues. Am I subtracting 75, even though it's a positive number? How do I make sure that I don't end up accidentally calculating my new debt as $1075 this month, $1150 next month, and so on? The answer is absolute values.

The absolute value of a number is simply its value regardless of positive or negative signs. When taking the absolute value of an addition/subtraction formula, such as , the order and signs of the calculation can be ignored. ABS(-1000+75) has the exact same value as ABS(75-1000), which in turn has the exact same value as ABS(1000-75). In all cases, your answer is 925: the value of your new debt after your monthly payment.

=ABS() is simply used to get the non-negative, signless value of any numerical data. Any cell, formula, or function can be listed within the parentheses enclosing the ABS function. But as with all functions, be careful to close every set of parentheses correctly. We will cover more on this crucial step in Chapter 9: Combining Functions.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.